package com.chenailin.www.dao;

import com.chenailin.www.pojo.Rating;

import java.sql.SQLException;
import java.util.List;

public interface RatingDAO {

    // 添加评价
    boolean addRating(Rating rating) throws SQLException;

    // 查询医生评价
    List<Rating> getRatingsByDoctor(int doctorId);

    // 查询科室评价
    List<Rating> getRatingsByDepartment(int departmentId);

    // 获取平均服务评分
    double getAverageRatingByDoctor(int doctorId);

    // 获取平均科室评分
    double getAverageDepartmentRating(int departmentId);

}
